-- created by kumiler
-- on 2022/12/28 14:57
-- DESC

insert overwrite table jms_dim.dim_tab_dw_market_signtimely_base
    select
    id,
    project_name,
    origin_provice_id,
    origin_provice_name,
    origin_city_id,
    origin_city_name,
    purpose_province_id,
    purpose_province_name,
    purpose_city_id,
    purpose_city_name,
    region_type,
    timely_type,
    city_timely1,
    city_t_timely,
    line,
    create_by,
    update_by,
    date_format(create_time,'yyyy-MM-dd HH:mm:ss') as create_time,
    date_format(update_time,'yyyy-MM-dd HH:mm:ss') as update_time
from jms_ods.tab_dw_market_signtimely
where dt = '{{ execution_date | cst_ds }}'
;